﻿

CREATE PROCEDURE [dbo].[exbug_UpdateDepartamenteParametrii]
	@codUnitate smallint, 
	@An smallint,
	@Luna smallint
AS
BEGIN
	SET NOCOUNT ON;
	UPDATE [Departamente] SET
	NumericField = a.NrPaturi,
	Suprafata = a.Suprafata
	FROM DepartamenteParametrii a
	WHERE a.IDDepartament = [Departamente].IDDepartament AND a.CodUnitate = @codUnitate
	AND An = @an aND Luna = @luna

	
END